Course Detail

Home > Professional Development Courses >

Learning the Magic of Macros

Introduction

Course Objectives

Through the process of creating a customized worksheet function, you will learn..
1. the essential for creating a macro;
2. the commonly used codes that will unleash the power of macros;
3. sharing your customized worksheet function with others.

Course Outline

1. Creating your very first macro through recording;
2. Where are macros stored in the workbook;
3. Understanding how a specific set of codes does;
4. Writing to and reading from a specific cell;
5. Create a set of codes instantly without knowing what the codes are beforehand;
6. Making a set of codes run based on a set of pre-defined criteria;
7. How to repeat a set of actions
8. Allowing users inputs into the macros
9. Returning the results to the cell e.g. presenting the total in the cell when a sum formula keyed in
10. Sharing your customized worksheet functions with others
11. Installing, uninstalling and removing the customized worksheet functions from a computer
12. Providing description for your worksheet functions
13. Protecting your customized worksheet functions

Trainer(s)

Mr Khoo, Jason

Jason Khoo is the author of “Excel Secrets for Highly Effective Marketers” and founder and chief trainer of a self-established company which has successfully differentiated itself by offering Microsoft® Excel Courses that empower participants with knowledge of applying the different functions and formulas in Excel to real business needs and scenarios.

An expert in spreadsheets and databases, Jason also founded a consultancy firm which has helped many companies extract valuable information from databases using Microsoft® Excel and save significant amount of money by providing solutions using just existing PC applications such as MS Excel.

Spanning the gamut of large, medium and small companies in a myriad of different industries, his clients include multi-nationals corporations such as Discovery Asia, 3M, NCS, Cold Storage, Timberland, etc.

Prior to setting up his businesses, Jason has worked in local listed companies and foreign MNCs supporting the marketers in their analysis of marketing plans and providing quality information for business strategic planning and decision-making. He was also a financial counsel for a business unit in a Fortune 500 company which generated a total revenue of more than S$100 million per annum.

Who Should Attend

This course is specially tailored for business managers and executives who have an extensive knowledge of Excel and need to simplify complex calculation or automate manual tasks.

Course Details

Date:

9 to 10 November 2009

Time:

9:00am to 5:00pm

Venue:

NTU@one-north campus, Executive Centre

Closing Date:

26 October 2009

Fee:

Standard: SGD$780 Alumni: SGD$624 Group (3 & Above): SGD$702

Registration fees inclusive of:

Course materials
Light refreshments
Lunch
Complimentary parking (1 entry/day) - applicable at NTU@one-north campus only.
Prevailing GST

Online Registration

>> CLICK HERE to Register Online

Methods of Payment

1. Credit Card (Visa and Mastercard only)

2. Cheque made payable to Nanyang Technological University

3. Invoice to Company (for Company Sponsored Participants)

4. E-invoice (for Government Organizations)

Cancellation & Refund Policy

Written notification to cce@ntu.edu.sg or fax: (+65) 6774 2911 at least 10 days before course commencement	No cancellation charges (Full refund)
Written notification within 4 – 9 days before course commencement	50% of course fees (50% refund)
Written notification within 3 days before course commencement	100% of course fees (No refund)